package org.example.entity;

import com.alibaba.excel.annotation.ExcelProperty;
import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import lombok.Data;

import java.math.BigDecimal;
import java.time.LocalDateTime;

/**
 * 投资数据表实体
 */
@Data
@TableName("investment_data")
public class InvestmentData {
    
    @TableId(type = IdType.AUTO)
    private Long id;
    
    @ExcelProperty(value = "放款月", index = 0)
    private String periodDate;
    
    @ExcelProperty(value = "订单数", index = 1)
    private String orderCount;
    
    @ExcelProperty(value = "放款笔数", index = 2)
    private String investmentCount;
    
    @ExcelProperty(value = "放款金额", index = 3)
    private BigDecimal investmentAmount;
    
    // FPB1 数据
    @ExcelProperty(value = "FPB1+客户数", index = 4 )
    private String fpb1Customers;
    
    @ExcelProperty(value = "FPB1+金额", index = 5)
    private BigDecimal fpb1Amount;
    
    @ExcelProperty(value = "FPB1+客户占比", index = 6)
    private String fpb1CustomersPercentage;
    
    @ExcelProperty(value = "FPB1+金额占比", index = 7)
    private String fpb1AmountPercentage;
    
    // FPB2 数据
    @ExcelProperty(value = "FPB2+客户数", index = 8)
    private String fpb2Customers;
    
    @ExcelProperty(value = "FPB2+金额", index = 9)
    private BigDecimal fpb2Amount;
    
    @ExcelProperty(value = "FPB2+客户占比", index = 10)
    private String fpb2CustomersPercentage;
    
    @ExcelProperty(value = "FPB2+金额占比", index = 11)
    private String fpb2AmountPercentage;
    
    // FPB3 数据
    @ExcelProperty(value = "FPB3+客户数", index = 12)
    private String fpb3Customers;
    
    @ExcelProperty(value = "FPB3+金额", index = 13)
    private BigDecimal fpb3Amount;
    
    @ExcelProperty(value = "FPB3+客户占比", index = 14)
    private String fpb3CustomersPercentage;
    
    @ExcelProperty(value = "FPB3+金额占比", index = 15)
    private String fpb3AmountPercentage;
    
    // FPB4 数据
    @ExcelProperty(value = "FPB4+客户数", index = 16)
    private String fpb4Customers;
    
    @ExcelProperty(value = "FPB4+金额", index = 17)
    private BigDecimal fpb4Amount;
    
    @ExcelProperty(value = "FPB4+客户占比", index = 18)
    private String fpb4CustomersPercentage;
    
    @ExcelProperty(value = "FPB4+金额占比", index = 19)
    private String fpb4AmountPercentage;
    
    // FPB5 数据
    @ExcelProperty(value = "FPB5+客户数", index = 20)
    private String fpb5Customers;
    
    @ExcelProperty(value = "FPB5+金额", index = 21)
    private BigDecimal fpb5Amount;
    
    @ExcelProperty(value = "FPB5+客户占比", index = 22)
    private String fpb5CustomersPercentage;
    
    @ExcelProperty(value = "FPB5+金额占比", index = 23)
    private String fpb5AmountPercentage;
    
    // FPB6 数据
    @ExcelProperty(value = "FPB6+客户数", index = 24)
    private String fpb6Customers;
    
    @ExcelProperty(value = "FPB6+金额", index = 25)
    private BigDecimal fpb6Amount;
    
    @ExcelProperty(value = "FPB6+客户占比", index = 26)
    private String fpb6CustomersPercentage;
    
    @ExcelProperty(value = "FPB6+金额占比", index = 27)
    private String fpb6AmountPercentage;
    
    // FPB7 数据
    @ExcelProperty(value = "FPB7+客户数", index = 28)
    private String fpb7Customers;
    
    @ExcelProperty(value = "FPB7+金额", index = 29)
    private BigDecimal fpb7Amount;
    
    @ExcelProperty(value = "FPB7+客户占比", index = 30)
    private String fpb7CustomersPercentage;
    
    @ExcelProperty(value = "FPB7+金额占比", index = 31)
    private String fpb7AmountPercentage;
    
    // FPB15 数据
    @ExcelProperty(value = "FPB15+客户数", index = 32)
    private String fpb15Customers;
    
    @ExcelProperty(value = "FPB15+金额", index = 33)
    private BigDecimal fpb15Amount;
    
    @ExcelProperty(value = "FPB15+客户占比", index = 34)
    private String fpb15CustomersPercentage;
    
    @ExcelProperty(value = "FPB15+金额占比", index = 35)
    private String fpb15AmountPercentage;
    
    // FPB30 数据
    @ExcelProperty(value = "FPB30+客户数", index = 36)
    private String fpb30Customers;
    
    @ExcelProperty(value = "FPB30+金额", index = 37)
    private BigDecimal fpb30Amount;
    
    @ExcelProperty(value = "FPB30+客户占比", index = 38)
    private String fpb30CustomersPercentage;
    
    @ExcelProperty(value = "FPB30+金额占比", index = 39)
    private String fpb30AmountPercentage;
    
    // FPB60 数据
    @ExcelProperty(value = "FPB60+客户数", index = 40)
    private String fpb60Customers;
    
    @ExcelProperty(value = "FPB60+金额", index = 41)
    private BigDecimal fpb60Amount;
    
    @ExcelProperty(value = "FPB60+客户占比", index = 42)
    private String fpb60CustomersPercentage;
    
    @ExcelProperty(value = "FPB60+金额占比", index = 43)
    private String fpb60AmountPercentage;
    
    // FPB90 数据
    @ExcelProperty(value = "FPB90+客户数", index = 44)
    private String fpb90Customers;
    
    @ExcelProperty(value = "FPB90+金额", index = 45)
    private BigDecimal fpb90Amount;
    
    @ExcelProperty(value = "FPB90+客户占比", index = 46)
    private String fpb90CustomersPercentage;
    
    @ExcelProperty(value = "FPB90+金额占比", index = 47)
    private String fpb90AmountPercentage;
    
    private LocalDateTime createdTime;
    private LocalDateTime updatedTime;
}
